<?xml version="1.0" encoding="utf-8" ?>
<sqlMap namespace='Module' xmlns='http://ibatis.apache.org/mapping' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'>
  <alias>
    <typeAlias alias='Module' assembly='Janus.Mes.POCO.dll' type='Janus.Mes.POCO.Module' />
  </alias>
  <resultMaps>
    <resultMap id='ModuleResult' class='Module'>
	<result property='ID' column='ID ' /> 
	<result property='ModuleName' column='ModuleName ' /> 
	<result property='Title' column='Title ' /> 
	<result property='Url' column='Url ' /> 
	<result property='Order' column='Order ' /> 
	<result property='Parent' column='Parent ' /> 
	<result property='Remark' column='Remark ' /> 
	<result property='GUID' column='GUID ' /> 
	<result property='AdXml' column='AdXml ' /> 
	<result property='Types' column='Types ' /> 
	<result property='ParmFormat' column='ParmFormat ' /> 
	<result property='OnCilck' column='OnCilck ' /> 
	<result property='CssClass' column='CssClass ' /> 
	<result property='Target' column='Target ' /> 
	<result property='External' column='External ' /> 
	<result property='Fresh' column='Fresh ' /> 
	<result property='Warn' column='Warn ' /> 
	<result property='Reverse' column='Reverse ' /> 
	<result property='Index' column='Index ' /> 
	<result property='CallBack' column='CallBack ' /> 
	<result property='Width' column='Width ' /> 
	<result property='Height' column='Height ' /> 
	<result property='Max' column='Max ' /> 
	<result property='IsRefresh' column='IsRefresh ' /> 
	<result property='IsDisable' column='IsDisable ' /> 
		</resultMap>
  </resultMaps>  
  <statements>
  <sql id="UpdaterConditions">  
  <dynamic prepend="SET">
      	<isPropertyAvailable prepend="" property="ModuleName">
        <isNotEmpty prepend="," property="ModuleName">
		          [ModuleName]=#ModuleName#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="Title">
        <isNotEmpty prepend="," property="Title">
		          [Title]=#Title#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="Url">
        <isNotEmpty prepend="," property="Url">
		          [Url]=#Url#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="Order">
        <isNotEmpty prepend="," property="Order">
		          [Order]=#Order#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="Parent">
        <isNotEmpty prepend="," property="Parent">
		          [Parent]=#Parent#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="Remark">
        <isNotEmpty prepend="," property="Remark">
		          [Remark]=#Remark#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="GUID">
        <isNotEmpty prepend="," property="GUID">
		          [GUID]=#GUID#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="AdXml">
        <isNotEmpty prepend="," property="AdXml">
		          [AdXml]=#AdXml#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="Types">
        <isNotEmpty prepend="," property="Types">
		          [Types]=#Types#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="ParmFormat">
        <isNotEmpty prepend="," property="ParmFormat">
		          [ParmFormat]=#ParmFormat#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="OnCilck">
        <isNotEmpty prepend="," property="OnCilck">
		          [OnCilck]=#OnCilck#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="CssClass">
        <isNotEmpty prepend="," property="CssClass">
		          [CssClass]=#CssClass#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="Target">
        <isNotEmpty prepend="," property="Target">
		          [Target]=#Target#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="External">
        <isNotEmpty prepend="," property="External">
		          [External]=#External#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="Fresh">
        <isNotEmpty prepend="," property="Fresh">
		          [Fresh]=#Fresh#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="Warn">
        <isNotEmpty prepend="," property="Warn">
		          [Warn]=#Warn#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="Reverse">
        <isNotEmpty prepend="," property="Reverse">
		          [Reverse]=#Reverse#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="Index">
        <isNotEmpty prepend="" property="Index">
				  <isNotEqual prepend="," property="Index" compareValue="0">
		          [Index]=#Index#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="CallBack">
        <isNotEmpty prepend="," property="CallBack">
		          [CallBack]=#CallBack#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="Width">
        <isNotEmpty prepend="," property="Width">
		          [Width]=#Width#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="Height">
        <isNotEmpty prepend="," property="Height">
		          [Height]=#Height#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="Max">
        <isNotEmpty prepend="," property="Max">
		          [Max]=#Max#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="IsRefresh">
        <isNotEmpty prepend="" property="IsRefresh">
				  <isNotEqual prepend="," property="IsRefresh" compareValue="false">
		          [IsRefresh]=#IsRefresh#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="IsDisable">
        <isNotEmpty prepend="" property="IsDisable">
				  <isNotEqual prepend="," property="IsDisable" compareValue="false">
		          [IsDisable]=#IsDisable#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>	
	  	 </dynamic>
    </sql>
	<sql id="WhereConditions">
	 <dynamic prepend="WHERE">
	 	 <isPropertyAvailable prepend="" property="ID">
        <isNotEmpty prepend="AND" property="ID">
		          [ID]=#ID#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="ModuleName">
        <isNotEmpty prepend="AND" property="ModuleName">
		          [ModuleName]=#ModuleName#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="Title">
        <isNotEmpty prepend="AND" property="Title">
		          [Title]=#Title#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="Url">
        <isNotEmpty prepend="AND" property="Url">
		          [Url]=#Url#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="Order">
        <isNotEmpty prepend="AND" property="Order">
		          [Order]=#Order#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="Parent">
        <isNotEmpty prepend="AND" property="Parent">
		          [Parent]=#Parent#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="Remark">
        <isNotEmpty prepend="AND" property="Remark">
		          [Remark]=#Remark#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="GUID">
        <isNotEmpty prepend="AND" property="GUID">
		          [GUID]=#GUID#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="AdXml">
        <isNotEmpty prepend="AND" property="AdXml">
		          [AdXml]=#AdXml#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="Types">
        <isNotEmpty prepend="AND" property="Types">
		          [Types]=#Types#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="ParmFormat">
        <isNotEmpty prepend="AND" property="ParmFormat">
		          [ParmFormat]=#ParmFormat#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="OnCilck">
        <isNotEmpty prepend="AND" property="OnCilck">
		          [OnCilck]=#OnCilck#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="CssClass">
        <isNotEmpty prepend="AND" property="CssClass">
		          [CssClass]=#CssClass#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="Target">
        <isNotEmpty prepend="AND" property="Target">
		          [Target]=#Target#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="External">
        <isNotEmpty prepend="AND" property="External">
		          [External]=#External#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="Fresh">
        <isNotEmpty prepend="AND" property="Fresh">
		          [Fresh]=#Fresh#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="Warn">
        <isNotEmpty prepend="AND" property="Warn">
		          [Warn]=#Warn#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="Reverse">
        <isNotEmpty prepend="AND" property="Reverse">
		          [Reverse]=#Reverse#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="Index">
        <isNotEmpty prepend="" property="Index">
				  <isNotEqual prepend="AND" property="Index" compareValue="0">
		          [Index]=#Index#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="CallBack">
        <isNotEmpty prepend="AND" property="CallBack">
		          [CallBack]=#CallBack#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="Width">
        <isNotEmpty prepend="AND" property="Width">
		          [Width]=#Width#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="Height">
        <isNotEmpty prepend="AND" property="Height">
		          [Height]=#Height#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="Max">
        <isNotEmpty prepend="AND" property="Max">
		          [Max]=#Max#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="IsRefresh">
        <isNotEmpty prepend="" property="IsRefresh">
				  <isNotEqual prepend="AND" property="IsRefresh" compareValue="false">
		          [IsRefresh]=#IsRefresh#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="IsDisable">
        <isNotEmpty prepend="" property="IsDisable">
				  <isNotEqual prepend="AND" property="IsDisable" compareValue="false">
		          [IsDisable]=#IsDisable#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>
	  </dynamic> 
    </sql>
	<sql id="InsertPublic">
      INSERT INTO Module(
	     <dynamic prepend=" ">
       	   <isPropertyAvailable prepend="" property="ID">
        <isNotEmpty prepend="," property="ID">
          [ID]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="ModuleName">
        <isNotEmpty prepend="," property="ModuleName">
          [ModuleName]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="Title">
        <isNotEmpty prepend="," property="Title">
          [Title]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="Url">
        <isNotEmpty prepend="," property="Url">
          [Url]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="Order">
        <isNotEmpty prepend="," property="Order">
          [Order]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="Parent">
        <isNotEmpty prepend="," property="Parent">
          [Parent]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="Remark">
        <isNotEmpty prepend="," property="Remark">
          [Remark]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="GUID">
        <isNotEmpty prepend="," property="GUID">
          [GUID]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="AdXml">
        <isNotEmpty prepend="," property="AdXml">
          [AdXml]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="Types">
        <isNotEmpty prepend="," property="Types">
          [Types]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="ParmFormat">
        <isNotEmpty prepend="," property="ParmFormat">
          [ParmFormat]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="OnCilck">
        <isNotEmpty prepend="," property="OnCilck">
          [OnCilck]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="CssClass">
        <isNotEmpty prepend="," property="CssClass">
          [CssClass]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="Target">
        <isNotEmpty prepend="," property="Target">
          [Target]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="External">
        <isNotEmpty prepend="," property="External">
          [External]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="Fresh">
        <isNotEmpty prepend="," property="Fresh">
          [Fresh]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="Warn">
        <isNotEmpty prepend="," property="Warn">
          [Warn]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="Reverse">
        <isNotEmpty prepend="," property="Reverse">
          [Reverse]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="Index">
        <isNotEmpty prepend="," property="Index">
          [Index]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="CallBack">
        <isNotEmpty prepend="," property="CallBack">
          [CallBack]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="Width">
        <isNotEmpty prepend="," property="Width">
          [Width]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="Height">
        <isNotEmpty prepend="," property="Height">
          [Height]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="Max">
        <isNotEmpty prepend="," property="Max">
          [Max]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="IsRefresh">
        <isNotEmpty prepend="," property="IsRefresh">
          [IsRefresh]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="IsDisable">
        <isNotEmpty prepend="," property="IsDisable">
          [IsDisable]
        </isNotEmpty>
      </isPropertyAvailable>
	  </dynamic>
      )
      VALUES
      (
	   <dynamic prepend=" ">
      	<isPropertyAvailable prepend="" property="ID">
        <isNotEmpty prepend="," property="ID">		
         #ID#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="ModuleName">
        <isNotEmpty prepend="," property="ModuleName">		
         #ModuleName#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="Title">
        <isNotEmpty prepend="," property="Title">		
         #Title#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="Url">
        <isNotEmpty prepend="," property="Url">		
         #Url#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="Order">
        <isNotEmpty prepend="," property="Order">		
         #Order#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="Parent">
        <isNotEmpty prepend="," property="Parent">		
         #Parent#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="Remark">
        <isNotEmpty prepend="," property="Remark">		
         #Remark#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="GUID">
        <isNotEmpty prepend="," property="GUID">		
         #GUID#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="AdXml">
        <isNotEmpty prepend="," property="AdXml">		
         #AdXml#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="Types">
        <isNotEmpty prepend="," property="Types">		
         #Types#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="ParmFormat">
        <isNotEmpty prepend="," property="ParmFormat">		
         #ParmFormat#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="OnCilck">
        <isNotEmpty prepend="," property="OnCilck">		
         #OnCilck#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="CssClass">
        <isNotEmpty prepend="," property="CssClass">		
         #CssClass#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="Target">
        <isNotEmpty prepend="," property="Target">		
         #Target#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="External">
        <isNotEmpty prepend="," property="External">		
         #External#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="Fresh">
        <isNotEmpty prepend="," property="Fresh">		
         #Fresh#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="Warn">
        <isNotEmpty prepend="," property="Warn">		
         #Warn#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="Reverse">
        <isNotEmpty prepend="," property="Reverse">		
         #Reverse#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="Index">
        <isNotEmpty prepend="," property="Index">		
         #Index#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="CallBack">
        <isNotEmpty prepend="," property="CallBack">		
         #CallBack#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="Width">
        <isNotEmpty prepend="," property="Width">		
         #Width#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="Height">
        <isNotEmpty prepend="," property="Height">		
         #Height#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="Max">
        <isNotEmpty prepend="," property="Max">		
         #Max#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="IsRefresh">
        <isNotEmpty prepend="," property="IsRefresh">		
         #IsRefresh#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="IsDisable">
        <isNotEmpty prepend="," property="IsDisable">		
         #IsDisable#		
        </isNotEmpty>
      </isPropertyAvailable>
	  </dynamic>
      )
    </sql>
	<!-- Insert statement:新增Mapper-->
    <insert id='Insert' parameterClass='Module'>
      <include refid="InsertPublic"/>
    </insert>
    <!--Update statement:修改Mapper-->
    <update id='Update' parameterClass='Module'>
      UPDATE [Module] 
      <include refid="UpdaterConditions"/>
      WHERE 1=1
	  	  AND ID=#ID#
	      </update>
    <update id='UpdateSetion' parameterClass='hashtable'>
      UPDATE [Module] 
      <include refid="UpdaterConditions"/>
      WHERE $conditions$
    </update>
	<update id='Save' parameterClass='Module'>
      IF NOT EXISTS(SELECT 1 FROM [Module] WHERE 1=1  AND [ID]=#ID# )
      BEGIN
      <include refid="InsertPublic"/>
      END
      ELSE
      BEGIN
      UPDATE Module 
      <include refid="UpdaterConditions"/>
      WHERE  1=1
	  	  AND [ID]=#ID#
	        END
    </update>
	<delete id='Delete' parameterClass='hashtable'>
      DELETE FROM [Module] WHERE	  
        <![CDATA[  
	 [ID]=#pk0# 
        ]]>
    </delete>
    <delete id='DeleteWhere' parameterClass='string'>
      DELETE FROM [Module] WHERE $value$
    </delete>

    <!-- select by key statement:-->
    <select id='FindOne' parameterClass='hashtable' resultClass='Module'>
      SELECT * FROM Module WHERE      
        <![CDATA[
		[ID]=#pk0# 
        ]]>
    </select>
    <select id='FindAllCondition' parameterClass='string' resultClass='Module'>
      SELECT * FROM [Module] WHERE $value$
    </select>
    <select id='FindScalar' parameterClass='hashtable' resultClass='Module'>
      SELECT * FROM [Module] WHERE $conditions$
    </select>
    
    <select id='FindAllCount' parameterClass='string' resultClass='int'>
      SELECT COUNT(1) FROM [Module] WHERE $value$
    </select>
    <select id='FindByPage' parameterClass='string' resultClass='Module'>
      SELECT * FROM [Module] WHERE $value$
    </select>
  </statements>
</sqlMap>
